package org.mpremote.android.framework.database;

/**
 * Created by IntelliJ IDEA.
 * User: Gilad
 * Date: 01/10/2010
 * Time: 18:57:51
 */
public interface MPDatabaseConstants {

    static final int DATABASE_VERSION = 1;
    static final String MUSIC_DATABASE_NAME = "music.db";
    static final String ARTISTS_TABLE_NAME = "artists";
    static final String ALBUM_TABLE_NAME = "albums";
    static final String ARTISTS_TO_ALBUM_TABLE_NAME = "artists_to_albums";


    static final String CREATE_ARTISTS_TABLE = "CREATE TABLE " + ARTISTS_TABLE_NAME + " (name  TEXT , albums_url TEXT, playlist_add_url TEXT)";
    static final String CREATE_ALBUMS_TABLE = "CREATE TABLE " + ALBUM_TABLE_NAME + " (name TEXT, year TEXT, image_url TEXT, tracks_url TEXT, playlist_add_url TEXT)";
    static final String CREATE_ARTISTS_TO_ALBUM_TABLE = "CREATE TABLE " + ALBUM_TABLE_NAME + " (artist_name TEXT, album_name TEXT)";


    static final String ARTISTS_INSERT = "INSERT INTO " + ARTISTS_TABLE_NAME + " (name, albums_url, playlist_add_url) values (?,?,?)";
    static final String ALBUMS_INSERT = "INSERT INTO " + ALBUM_TABLE_NAME + " (name, year, image_url, tracks_url, playlist_add_url) values (?,?,?,?,?)";
    static final String ARTISTS_TO_ALBUM = "INSERT INTO " + ARTISTS_TO_ALBUM_TABLE_NAME + " (artist_name, album_name) values (?,?)";


}

